<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateDoctorsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('doctors', function (Blueprint $table) {
            $table->id();
            $table->string('name',100)->comment('医师姓名');
            $table->string('detail_link',500)->comment('医师详情链接');
            $table->string('doctor_img',500)->comment('医师照片');
            $table->string('type_name',100)->comment('医师类别');
            $table->string('place',200)->comment('医师工作地址');
            $table->string('department',100)->comment('医师所属科室');
            $table->string('attitude',50)->comment('医师态度');
            $table->decimal('price',10,2)->comment('起步看诊费');
            $table->tinyInteger('status')->comment('预约开通状态');
            $table->timestamps();
            //软删
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('doctors');
    }
}
